LCG is seeking a well-established Database Administrator who has a good blend of technical skills in application design, development, and system integration to support an existing Federal government customer. This is an exciting environment with multiple large projects and upgrades on-going and planned over the next 2 years. 

Essential Responsibilities: 

• All aspects of databases, including administration, data manipulation, security, and performance 

• Manage and maintain Oracle database servers in all environments 

• Monitor and tune queries and database performance 

• Monitor database, disk space, and logs 

• Design/Implement/Maintain backup/restore strategies per requirements 

• Provide support for software upgrades and patching 

• Diagnose and resolve production issues 

• Work with developers in Agile environment 

• Create users, control access, and maintain database security 

• Perform data migration tasks 

• Operate during normal business hours with some on call/after hours support as needed 

• Run complex queries to provide data, as requested, for reports 

• Set standards for database operations, programming, query processes, and security. 

• Model, design, and construct large relational databases or data warehouses. 

• Create and optimize data models for warehouse infrastructure and workflow. 

• Provide Oracle database expertise to support legacy applications 

• Provide database management support for all ITB initiatives 

• Ensure databases are designed in a manner that ensures maximum usability and value of the agency’s IT assets. 

• Collect, Record, and maintain accurate configuration information for all software and database configurations stored in configuration management tool. 

• Oracle database design, coding, and documentation. 

• Provide database backup procedures, recovery systems, and SQL. 

• Assist with schema design, code review, SQL query tuning 

• Install, tune, implement and upgrade DBMS installations 

• Write and deploy SQL patches 

• Altering storage structures to meet the evolving needs of the company. 

• Setting up database user accounts 

• Training users on how to access the information in the database. 

• Finding and debugging malfunctioning programs affecting the database integrity. 

Required Qualifications: 

• Mandatory (Oracle 19c) DBA Certification 

• Bachelor’s degree in computer science or a related information technology field 

• 8 to 10 years of experience as a Database Admin

• Proficient installing, configuring, maintaining and upgrading Oracle and SQL databases 

• Proficient installing, configuring, maintaining and upgrading Linux based database servers 

• Shell scripting in Data Base Development 

• Knowledge of JEE 

• Experience with monitoring Database capacity and performance 

• Experience with applying security patches and subsequent testing 

• Ability to refresh or clone databases from production to development 

• Experience using stored Procedures, Functions, Triggers and packages 

• Experience provisioning Microsoft SQL server instances 

• Experience with Microsoft SQL server clusters 

• Experience with AppDynamics or other performance monitoring tool 

• Experience provisioning MySQL instances 

• Experience interacting with users and customers regularly